Overview: Moving Statistics
Calculate statistics of the values of each field over a specified window. This window will move across rows of data, with the statistics being calculated either over a number of rows, i.e. index based window, or over a specified time period, i.e. time based window.
Statistics are calculated over the moving window as defined by using either the full data window or a partial data window, with the window size being determined by the good quality data threshold specified.
Properties
Category: |
Transform |
Performance risk: |
Low performance risk |
Knowledge required: |
Working knowledge of the software. |
Effect on datasets
How many datasets are required to perform this operation? |
One |
Does it create a new dataset? |
Yes |
Can you reconfigure this operation? |
Yes |
Can you apply this operation to a locked dataset? |
Yes |
Does it modify the current dataset in any way? |
No |
Requirements
-
For a index based window: dataset that contains at least one integer or double field.
-
For a time based window: dataset containing at least one integer or double field and one timestamp field.
Results
-
A new dataset containing the results of the selected statistics for the selected fields.
-
The resulting dataset will only contain the statistics of the selected fields, and none of the original values.
-
The original dataset will be unaffected by this operation.
Related topics: